Introduction

As a database engineer working with massive amounts of data, you need to build a proper database system that meets the data requirements of your business.

There are multiple database managements systems available for you to use. There are also different developments tools that you can use to create and manage your databases efficiently.

In this reading, you’ll review some of these systems, including:

This recap will support you in preparing for your exercise tasks.

MySQL

MySQL is an open-source relational database management system. It’s one of the most widely used management systems for building both personal and industry relational databases.

There are several advantages offered to database engineers who work with MySQL:

MySQL Workbench

MySQL Workbench is a unified visual tool for database modeling and database management. It was developed by Oracle, the company that manages MySQL.

MySQL Workbench is also free, open-source and cross-platform tool that runs on Windows, Mac and Linux. MySQL Workbench enables you to speed up the database design and development process.

Key features of MySQL Workbench include the following:

Installing MySQL Workbench

MySQL Workbench is open source and cross platform system available for Windows, Linux, and macOS.

Installing MySQL Workbench with MySQL server is a straightforward process. MySQL Workbench downloads are available at the MySQL website: https://dev.mysql.com/downloads/workbench/

For more details about the installation instructions, you can review the Installing MySQL Workbench item in the Advanced Data Modeling course.

Oracle provides detailed instructions about the MySQL Workbench installation process in the following link: https://dev.mysql.com/doc/refman/8.0/en/installing.html

SQL Basics

SQL (Structured Query Language) is the standard query language for accessing and manipulating relational databases. SQL provides four categories of commands to create, manipulate and manage data in a database known as DDL, DML, DCL and TCL.

If you want to learn more about each category of commands and how to use them, you can review Common SQL Commands item in the ‘Introduction to database’ course.

Database setup

There are few issues you need to consider when setting up MySQL Workbench to create and manage your databases.

In MySQL Workbench, you can create your database in different ways. For example, you can create and use your database by writing the relevant SQL statements.

Alternatively, you can create a data model in the model designer first, then transform it into a SQL schema that can be executed and implemented directly in a MySQL server without typing any SQL code.

To learn more about this process, you can review the Database modeling in MySQL Workbench item in the Advanced data modeling course.

Conclusion

In this reading you learned about the various categories of SQL commands, MySQL database management system and MySQL Workbench. You are now ready to start developing your database system and complete the different tasks in this lesson.